package com.lightkits.wms.database.dao;

import com.lightkits.wms.database.model.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface WmsWarehouseMapper {
    List<FndWarehouseModel> queryFndWarehouse(
            @Param("warehouseCode") String warehouseCode,
            @Param("organizationId") String organizationId,
            @Param("categroySet") String categroySet,
            @Param("wmAreaFlag") String wmAreaFlag);

    List<FndWarehouseByIdModel> quryWarehouseById(
            @Param("warehouseId") String warehouseId
    );

    List<KVCodeModel> querySysCode(
            @Param("code") String code,
            @Param("codeValue") String codeValue,
            @Param("codeMeaning")String codeMeaning);

    List<WorkerInfoModel> getWorekrInfoByParams(
            @Param("orgId") String orgId,
            @Param("workerGroupCode") String workerGroupCode,
            @Param("workerNumOrName") String workerNumOrName);

    List<ExceptionModel> getBadReasonByParams(
            @Param("orgId") String orgId,
            @Param("itemId") String itemId,
            @Param("startTime") String startTime,
            @Param("endTime") String endTime
    );
}
